[dbo].[OrderProductCrossSellLookup]

Property	Value
Row Count	1
Created	10:31:30 AM Tuesday, March 02, 2010
Last Modified	11:40:05 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:30 AM Tuesday, March 02, 2010

Last Modified

11:40:05 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key PK_OrderProductCrossSellLookup: OrderProductID\CrossSellOrderProductID$	OrderProductID	int	4
$Cluster Primary Key PK_OrderProductCrossSellLookup: OrderProductID\CrossSellOrderProductID$	CrossSellOrderProductID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_OrderProductCrossSellLookup: OrderProductID\CrossSellOrderProductID$

OrderProductID

int

$Cluster Primary Key PK_OrderProductCrossSellLookup: OrderProductID\CrossSellOrderProductID$

CrossSellOrderProductID

int

	Name	Columns	Unique
$Cluster Primary Key PK_OrderProductCrossSellLookup: OrderProductID\CrossSellOrderProductID$	PK_OrderProductCrossSellLookup	OrderProductID, CrossSellOrderProductID

Name

Columns

Unique

$Cluster Primary Key PK_OrderProductCrossSellLookup: OrderProductID\CrossSellOrderProductID$

PK_OrderProductCrossSellLookup

OrderProductID, CrossSellOrderProductID

Name	Update	Delete	Columns
FK_OrderProductCrossSellLookup_OrderProduct	Cascade	Cascade	OrderProductID->[dbo].[OrderProduct].[OrderProductID]
FK_OrderProductCrossSellLookup_OrderProduct_CrossSell			CrossSellOrderProductID->[dbo].[OrderProduct].[OrderProductID]

Name

Update

Delete

Columns

FK_OrderProductCrossSellLookup_OrderProduct

Cascade

OrderProductID->[dbo].[OrderProduct].[OrderProductID]

FK_OrderProductCrossSellLookup_OrderProduct_CrossSell

CrossSellOrderProductID->[dbo].[OrderProduct].[OrderProductID]

SQL Script

CREATE TABLE [dbo].[OrderProductCrossSellLookup]
(
[OrderProductID] [int] NOT NULL,
[CrossSellOrderProductID] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OrderProductCrossSellLookup] ADD CONSTRAINT [PK_OrderProductCrossSellLookup] PRIMARY KEY CLUSTERED ([OrderProductID], [CrossSellOrderProductID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OrderProductCrossSellLookup] ADD CONSTRAINT [FK_OrderProductCrossSellLookup_OrderProduct] FOREIGN KEY ([OrderProductID]) REFERENCES [dbo].[OrderProduct] ([OrderProductID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[OrderProductCrossSellLookup] ADD CONSTRAINT [FK_OrderProductCrossSellLookup_OrderProduct_CrossSell] FOREIGN KEY ([CrossSellOrderProductID]) REFERENCES [dbo].[OrderProduct] ([OrderProductID])
GO